<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<%@ page import = "cs633.util.DBManager" %>
<%@ page import = "java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
 <script type="text/javascript" src="js/jquery-1.7.1.min.js"></script>
 <script type="text/javascript">
 $(document).ready(function() {
	   $("a").click(function() {
	     alert("Hello world!");
	   });
	 });
 
 </script>
<title>Hello</title>
</head>
<body>
<a href="">Link</a>

<%
String first = null;
String last = null;
	try {
	Connection con = DBManager.getInstance().getConn();
	Statement stmt = con.createStatement();
	ResultSet rs = stmt.executeQuery("SELECT * FROM cs633.user");

	while (rs.next()) {
		first = rs.getString("USER_FIRST_NAME");
		last = rs.getString("USER_LAST_NAME");
	}
	con.close();
	} catch (Exception e) {
		System.out.println("Error: " + e.getMessage());
	}
%>

Hello World: <%= first %> <%= last %>
</body>
</html>